﻿<%@ Page Title="图书管理" Language="C#" MasterPageFile="~/Common2.Master" AutoEventWireup="true" CodeBehind="WebAdmin3.aspx.cs" Inherits="loginWeb.WebAdmin3" %>
<asp:Content ID="Content1" ContentPlaceHolderID="head" runat="server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" runat="server">
</asp:Content>
<asp:Content ID="Content3" ContentPlaceHolderID="ContentPlaceHolder2" runat="server">
    <asp:DetailsView ID="DetailsView1" runat="server" AllowPaging="True" AutoGenerateRows="False" CellPadding="4" DataKeyNames="书号ID" DataSourceID="SqlDataSource1" Font-Size="X-Large" ForeColor="#333333" GridLines="None" Height="50px" style="margin-left: 283px; margin-top: 82px" Width="800px">
        <AlternatingRowStyle BackColor="White" ForeColor="#284775" />
        <CommandRowStyle BackColor="#E2DED6" Font-Bold="True" />
        <EditRowStyle BackColor="#999999" />
        <FieldHeaderStyle BackColor="#E9ECF1" Font-Bold="True" />
        <Fields>
            <asp:BoundField DataField="书号ID" HeaderText="书号ID" ReadOnly="True" SortExpression="书号ID" />
            <asp:BoundField DataField="书名" HeaderText="书名" SortExpression="书名" />
            <asp:BoundField DataField="作者" HeaderText="作者" SortExpression="作者" />
            <asp:BoundField DataField="简介" HeaderText="简介" SortExpression="简介" />
            <asp:CommandField ShowDeleteButton="True" ShowEditButton="True" ShowInsertButton="True" />
        </Fields>
        <FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
        <HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
        <PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" />
        <RowStyle BackColor="#F7F6F3" ForeColor="#333333" />
    </asp:DetailsView>
    <br />
    <asp:ImageButton ID="ImageButton3" runat="server" ImageUrl="~/image/返回 啊.png" OnClick="ImageButton3_Click" PostBackUrl="~/WebAdmin1.aspx" style="margin-left: 0px" Width="156px" />
    <br />
    <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConflictDetection="CompareAllValues" ConnectionString="<%$ ConnectionStrings:dhd2014112109ConnectionString %>" DeleteCommand="DELETE FROM [Book] WHERE [书号ID] = @original_书号ID AND [书名] = @original_书名 AND (([作者] = @original_作者) OR ([作者] IS NULL AND @original_作者 IS NULL)) AND (([简介] = @original_简介) OR ([简介] IS NULL AND @original_简介 IS NULL))" InsertCommand="INSERT INTO [Book] ([书号ID], [书名], [作者], [简介]) VALUES (@书号ID, @书名, @作者, @简介)" OldValuesParameterFormatString="original_{0}" SelectCommand="SELECT [书号ID], [书名], [作者], [简介] FROM [Book]" UpdateCommand="UPDATE [Book] SET [书名] = @书名, [作者] = @作者, [简介] = @简介 WHERE [书号ID] = @original_书号ID AND [书名] = @original_书名 AND (([作者] = @original_作者) OR ([作者] IS NULL AND @original_作者 IS NULL)) AND (([简介] = @original_简介) OR ([简介] IS NULL AND @original_简介 IS NULL))">
        <DeleteParameters>
            <asp:Parameter Name="original_书号ID" Type="String" />
            <asp:Parameter Name="original_书名" Type="String" />
            <asp:Parameter Name="original_作者" Type="String" />
            <asp:Parameter Name="original_简介" Type="String" />
        </DeleteParameters>
        <InsertParameters>
            <asp:Parameter Name="书号ID" Type="String" />
            <asp:Parameter Name="书名" Type="String" />
            <asp:Parameter Name="作者" Type="String" />
            <asp:Parameter Name="简介" Type="String" />
        </InsertParameters>
        <UpdateParameters>
            <asp:Parameter Name="书名" Type="String" />
            <asp:Parameter Name="作者" Type="String" />
            <asp:Parameter Name="简介" Type="String" />
            <asp:Parameter Name="original_书号ID" Type="String" />
            <asp:Parameter Name="original_书名" Type="String" />
            <asp:Parameter Name="original_作者" Type="String" />
            <asp:Parameter Name="original_简介" Type="String" />
        </UpdateParameters>
    </asp:SqlDataSource>
</asp:Content>
